SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{14d47f7a6217168cb05c0b0929a212b3e4e857489e49582943d43ec35a280db4}Cancelada{14d47f7a6217168cb05c0b0929a212b3e4e857489e49582943d43ec35a280db4}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{14d47f7a6217168cb05c0b0929a212b3e4e857489e49582943d43ec35a280db4}Cancelada{14d47f7a6217168cb05c0b0929a212b3e4e857489e49582943d43ec35a280db4}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{14d47f7a6217168cb05c0b0929a212b3e4e857489e49582943d43ec35a280db4}Spain{14d47f7a6217168cb05c0b0929a212b3e4e857489e49582943d43ec35a280db4}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{14d47f7a6217168cb05c0b0929a212b3e4e857489e49582943d43ec35a280db4}Spain{14d47f7a6217168cb05c0b0929a212b3e4e857489e49582943d43ec35a280db4}' OR prCountry = 'Spain')